"""
Copyright (c) 2022 Huawei Technologies Co.,Ltd.

openGauss is licensed under Mulan PSL v2.
You can use this software according to the terms and conditions of the Mulan PSL v2.
You may obtain a copy of Mulan PSL v2 at:

          http://license.coscl.org.cn/MulanPSL2

THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
See the Mulan PSL v2 for more details.
"""
"""
Case Type   : 系统内部使用工具
Case Name   : gs_ctl start只使用-D指定正确数据库实例目录启动备机
Create At   : 2021/01/15
Owner       : opentestcase015
Description :
    1.关闭正在运行的备机
    2.指定正确数据库实例目录启动备机
    3.查看集群状态
    4.恢复环境，启动备机
Expect      :
    1.关闭正在运行的备机成功
    2.指定正确数据库实例目录启动备机成功
    3.查看集群状态备机启动成功
    4.成功
History     :
    Modified by opentestcase027 2023/1/9: 优化用例步骤格式及一主两备判断方式
    Modified by opentestcase027 2023/5/6: step3查看集群状态前增加等待时间，待备机完成xlog
                                     redo,walreceiver发起连接后查看状态
"""

import unittest
import os
import time
from testcase.utils.Constant import Constant
from testcase.utils.CommonSH import CommonSH
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro

LOG = Logger()
primary_sh = CommonSH('PrimaryDbUser')


@unittest.skipIf(3 != primary_sh.get_node_num(), '非1+2环境不执行')
class LogicalReplication(unittest.TestCase):
    def setUp(self):
        LOG.info(f'--------{os.path.basename(__file__)} start--------')
        self.constant = Constant()
        self.sh_primary = CommonSH('PrimaryDbUser')
        self.PrimaryNode = Node('PrimaryDbUser')
        self.user_node = Node('Standby1DbUser')

    def test_system_internal_tools(self):
        LOG.info('--------step1:关闭正在运行的备机   expect:关闭成功--------')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl stop -D {macro.DB_INSTANCE_PATH} 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        self.assertIn(self.constant.GS_CTL_STOP_SUCCESS_MSG, msg)

        LOG.info('----step2:指定正确数据库实例目录启动备机   expect:启动成功----')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl start -D {macro.DB_INSTANCE_PATH} -M standby; 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        self.assertIn(self.constant.RESTART_SUCCESS_MSG, msg)

        LOG.info('--------step3:查看集群状态   expect:备机启动成功--------')
        time.sleep(5)
        status = self.sh_primary.get_db_cluster_status(param='detail')
        self.assertTrue(len(status.splitlines()) >= 10)
        self.assertIn('Standby Normal', status.splitlines()[-2])

    def tearDown(self):
        LOG.info('--------step4:启动备机   expect:成功--------')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl start -D {macro.DB_INSTANCE_PATH} -M standby; 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        status = self.sh_primary.get_db_cluster_status(param='detail')
        self.assertTrue(len(status.splitlines()) >= 10)
        self.assertIn('Standby Normal', status.splitlines()[-2])
        LOG.info(f'--------{os.path.basename(__file__)} end--------')
